Tabela PhAccPeriodSummItem

Definicja tabeli PhAccPeriodSummItem

Name

PhAccPeriodSummItem

Code

PhAccPeriodSummItem

Comment

 


Lista kolumn tabeli PhAccPeriodSummItem

Name

Code

AccPeriodSummItemId

AccPeriodSummItemId

AccPeriodSummId

AccPeriodSummId

StDocTypeID

StDocTypeID

StDocKindID

StDocKindID

ResourceTypeID

ResourceTypeID

DrugClassID

DrugClassID

StItemKindID

StItemKindID

StItemGroupID

StItemGroupID

CostAccountNo

CostAccountNo

SdCount

SdCount

valueGross

valueGross


Kolumna AccPeriodSummItemId tabeli PhAccPeriodSummItem

Definicja kolumny AccPeriodSummItemId tabeli PhAccPeriodSummItem

Name

AccPeriodSummItemId

Code

AccPeriodSummItemId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AccPeriodSummId tabeli PhAccPeriodSummItem

Definicja kolumny AccPeriodSummId tabeli PhAccPeriodSummItem

Name

AccPeriodSummId

Code

AccPeriodSummId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StDocTypeID tabeli PhAccPeriodSummItem

Definicja kolumny StDocTypeID tabeli PhAccPeriodSummItem

Name

StDocTypeID

Code

StDocTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StDocKindID tabeli PhAccPeriodSummItem

Definicja kolumny StDocKindID tabeli PhAccPeriodSummItem

Name

StDocKindID

Code

StDocKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceTypeID tabeli PhAccPeriodSummItem

Definicja kolumny ResourceTypeID tabeli PhAccPeriodSummItem

Name

ResourceTypeID

Code

ResourceTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DrugClassID tabeli PhAccPeriodSummItem

Definicja kolumny DrugClassID tabeli PhAccPeriodSummItem

Name

DrugClassID

Code

DrugClassID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StItemKindID tabeli PhAccPeriodSummItem

Definicja kolumny StItemKindID tabeli PhAccPeriodSummItem

Name

StItemKindID

Code

StItemKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StItemGroupID tabeli PhAccPeriodSummItem

Definicja kolumny StItemGroupID tabeli PhAccPeriodSummItem

Name

StItemGroupID

Code

StItemGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostAccountNo tabeli PhAccPeriodSummItem

Definicja kolumny CostAccountNo tabeli PhAccPeriodSummItem

Name

CostAccountNo

Code

CostAccountNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna SdCount tabeli PhAccPeriodSummItem

Definicja kolumny SdCount tabeli PhAccPeriodSummItem

Name

SdCount

Code

SdCount

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

ilosc dokumentów


Kolumna valueGross tabeli PhAccPeriodSummItem

Definicja kolumny valueGross tabeli PhAccPeriodSummItem

Name

valueGross

Code

valueGross

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

suma wartosci dokumentów


Lista kluczy tabeli PhAccPeriodSummItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhAccPeriodSummItem

Definicja klucza Identifier_1 tabeli PhAccPeriodSummItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment